You are here: Main Menu > I. Interface Menu > 7. External System > G. ESI Value Adjustments

ESI Value Adjustments

The ESI Value Adjustments function creates the export file for all value added cost adjustments for the period selected – see Value Added Analysis Report for more information.

1. Follow the common External System Interface (ESI) overview and instructions found in the ESI menu overview.

2. At the Period field, enter the accounting period for the ESI value adjustment file.

3. At the Year field, enter the year for the file.

If the file name and type selected already exist, the following message will display: "Warning: File already exists!!! Continue? No/Yes."

Select no to return to the command options.
Select yes to create a new file with the same name that already exists.

4. The following message will display: "Print report? No/Yes."

Select no to generate the export file without a printed detail report.
Select yes to create the file with a printed detail report.

5. The following message will appear: "Create a delimited ASC file? No/Yes."

Select no to create a DBF file only.
Select yes to create a DBF file and an ASC file

Make the appropriate selection.

Two DBF files will be created VUPPYYYY.dbf and VU_Last.dbf in the Shared \NetYield\Data\Company Name\ESI Outbox folder. The VUPPYYYY.dbf file is the Value Adjustments file for the selected period and year with PPYYYY equal to the period and year selected. The VU_Last.dbf is a copy of the current file. If an ASC file was created, the name will be VUPPYYYY.asc and will be in the Shared \NetYield\Data\Company Name\ESI Outbox folder.

5. If you selected yes to print an ESI Value Adjustments report in Step #4, command options will appear allowing you to print or choose from a set of other print options.

The following fields print on the report:

Item – The item ID code
Group – The item class and subclass
Item Name – The item name
Dpt – The department assigned to the item
Cat – The sales category for the item
Buyer – The buyer ID
Typ – The transaction type for the value-type cost adjustment. See Value Added Analysis Report for more information.
Adj – The value type cost adjustment ID for the transaction
Who – The user ID that created the transaction
Date – The date of the transaction
Amount – The amount for the transaction line
Total – The total amount of the transaction
Grand total for all transactions.

The following fields will be exported from the system:

Field Name	Description	Type
PERIOD	The accounting period	C 2
YEAR	The accounting year	C 4
ITEM	The item code	C 8
MGMT_GROUP	The item class	C 5
ITEM_NAME	The item name	C 30
DEPARTMENT	The department assigned to the item	C 2
SALES_CAT	The sales category assigned to the item	C 2
BUYER	The category manager or buyer ID	C 6
TRANS_TYPE	The transaction type	C 2
ADJ_TYPE	The cost adjustment type	C 2
DESC	The transaction description	C 2
DATE	The transaction date	D 8
WHO	The user who made the cost adjustment	C 5
AMOUNT	The cost adjustment amount	N 10

Security Required : Ledger - Ledger Reports